﻿<%@ Page Title="Ad Hoc Research Explorer" Language="vb" MasterPageFile="~/Site.Master" AutoEventWireup="false"
    CodeBehind="Default.aspx.vb" Inherits="myproject._Default" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">

    <style type="text/css">
        .style3
        {
            height: 81px;
        }
        .style4
        {
            height: 57px;
        }
    </style>
</asp:Content>

<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
 
    
<!-- This place holder tag is to adding suitable stuff for suitable users "adding roles!" 

You can add any asp.net tag here, as long as active users or normal users need them -->

<asp:PlaceHolder runat="server" ID="ph_activeUsers">

Hey, You are Active User!

</asp:PlaceHolder>


             <br />
             <div align="left" lang="en">
      <table>
         <tr>
         <td>
           <div>
             <table width="500" cellspacing="30" style="border-style: groove">
             <tr>
             <td valign="middle">
             <h2 align="center" runat="server"> Highlights</h2>
             </td>
             </tr>
             <tr>
             <td align ="center">
             <p> See the latest research published so far!</p>
                 <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
                     DataKeyNames="ID" DataSourceID="HighlightsDataSource" Width ="550px" Height ="300px">
                     <Columns>
                         <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
                         <asp:BoundField DataField="Description" HeaderText="Description" 
                             SortExpression="Description" />
                     </Columns>
                     <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
        <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
        <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
        <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
        <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
        <SortedAscendingCellStyle BackColor="#F4F4FD" />
        <SortedAscendingHeaderStyle BackColor="#5A4C9D" />
        <SortedDescendingCellStyle BackColor="#D8D8F0" />
        <SortedDescendingHeaderStyle BackColor="#3E3277" />
                 </asp:GridView>
             
                 <asp:SqlDataSource ID="HighlightsDataSource" runat="server" 
                     ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
                     ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
                     SelectCommand="SELECT TOP 3 [ID], [Title], [Description] FROM [Researches]">
                 </asp:SqlDataSource>
                 <br />
             <asp:HyperLink ID="hl_goBack" runat="server" 
        NavigateUrl="~/ResearchList.aspx">Click here to see more researches </asp:HyperLink>
             </td>
             </tr>
             <tr align="center">
             <td>
             
             </td>
             </tr>
             </table>
           </div>
           
           <br />
           <br />
           

           
           <br />
           <br />

 
           </div>
         </td>
         <td>

             <table width="250" cellspacing="30" style="border-style: groove">
             <tr>
             <td>
             </td>
             </tr>
             <tr>
             <td>
             
             <h1 style="border-bottom-style: groove">Active Users</h1>
             <br />
                 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                     DataSourceID="NumberOfCommentsDataSource">
                     <Columns>
                         <asp:BoundField DataField="Author" HeaderText="User Name" 
                             SortExpression="Author" />
                         <asp:BoundField DataField="NumberOfComments" HeaderText="Number of Comments" 
                             SortExpression="NumberOfComments" />
                     </Columns>
                     <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
        <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
        <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
        <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
        <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
        <SortedAscendingCellStyle BackColor="#F4F4FD" />
        <SortedAscendingHeaderStyle BackColor="#5A4C9D" />
        <SortedDescendingCellStyle BackColor="#D8D8F0" />
        <SortedDescendingHeaderStyle BackColor="#3E3277" />
                 </asp:GridView>
                 <asp:SqlDataSource ID="NumberOfCommentsDataSource" runat="server" 
                     ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
                     ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand="SELECT Top 4 [Author], [NumberOfComments] FROM [NumberOfComments] WHERE NumberOfComments &gt; 2
ORDER BY NumberOfComments DESC"></asp:SqlDataSource>
             
             
             </td>
             </tr>
             <tr>
             <td>
             </td>
             </tr>
             <tr>
             <td>
             <h1 style="border-bottom-style: groove">Calender</h1>
             <br />

                 <asp:Calendar ID="Calendar1" runat="server" BackColor="White" 
                     BorderColor="#3366CC" BorderWidth="1px" CellPadding="1" 
                     DayNameFormat="Shortest" Font-Names="Verdana" Font-Size="8pt" 
                     ForeColor="#003399" Height="200px" Width="220px">
                     <DayHeaderStyle BackColor="#99CCCC" ForeColor="#336666" Height="1px" />
                     <NextPrevStyle Font-Size="8pt" ForeColor="#CCCCFF" />
                     <OtherMonthDayStyle ForeColor="#999999" />
                     <SelectedDayStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
                     <SelectorStyle BackColor="#99CCCC" ForeColor="#336666" />
                     <TitleStyle BackColor="#003399" BorderColor="#3366CC" BorderWidth="1px" 
                         Font-Bold="True" Font-Size="10pt" ForeColor="#CCCCFF" Height="25px" />
                     <TodayDayStyle BackColor="#99CCCC" ForeColor="White" />
                     <WeekendDayStyle BackColor="#CCCCFF" />
                 </asp:Calendar>
             <br />
             </td>
             
             </tr> 
             <tr>
             <td class="style3">

             <br />
            <br />
                
            <br />
            </td>
             </tr>
             </table>
         </td>
         </tr>
     </table>
     <br />
             </div>
             
             <div>
         <table>
         <tr>
         <td>
         </td>
         <td>
         </td>
         </tr>
     </table>
             </div>
   

</asp:Content>
